create table jms_dm.dm_download_sign_abnomal_cnt_dt (
                                                        agent_code varchar(30) comment '代理区code',
                                                        agent_name varchar(30) comment '代理区name',
                                                        waybill_cnt1 int comment '导数类型1单量',
                                                        waybill_cnt2 int comment '导数类型2单量',
                                                        waybill_cnt3 int comment '导数类型3单量',
                                                        waybill_cnt4 int comment '导数类型4单量',
                                                        repeat_cnt int comment '重复单量',
                                                        is_work_order int comment '客诉量',
                                                        is_flas_sign int comment '客诉_虚假签收量',
                                                        sign_cnt int comment '签收量',
                                                        date_time date comment '查询日期'
) ENGINE=OLAP
DUPLICATE KEY(agent_code)
COMMENT "下载中心_虚假签收明细汇总"
PARTITION BY RANGE(date_time)
(START ("2023-10-01") END ("2023-10-15") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(agent_code) BUCKETS 2
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-14",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "2",
"in_memory" = "false",
"storage_format" = "V2"
);